Excel Calendar with Visual Basic, I guess

[misbrandy]

I have a user with a spreadsheet that's been turned over to him to maintain. It is basically a newsletter (don't ask why they've used excel.....); anyway, it has an already built calendar inside. I cannot select the calendar (like I could an image or a field), I cannot modify it, cannot copy it, nothing. It doesn't even copy over when I copy the whole tab....leaves the calendar off.

I would like to keep the calendar, just as is, but be able to change the dates. None of my staff is skilled in this area.

I found instructions online on how to build a calendar from scratch with macro and Visual Basic, but can't find how to simply modify the existing with a new date.

Can anyone simplify this for me? Thanks!

 

[SkipVought]

Hi,

Can anyone simplify this for me?

Not without knowing a whole lot more about your existing calendar.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]