Macro custom view

[Guest]

I have a macro that was set up by someone else. When it run it it prints a
date at the top which is wrong. When I go into the macro it tells me it has
a custom view and when I change the date it will not run. I am not familiar
with custom views. Can anyone help me to change this date and get the macro
to run. See below
ActiveWorkbook.CustomViews("Compliance Test 6/30/2005").Show
I want to change the date to 6/30/2006

thank you mac

 

[Van T. Dinh]

Have you tried changing to "Compliance Test 6/30/2006"?

BTW, you posted in the wrong newsgroup. This newsgroup is for Microsoft
Access, a database application.

It looks like your question is related to Excel. If the above doesn't help,
try posing your question in one of the Excel newsgroups.