Visual basic message box error

[cmb80]

Hi, I have a macro run when a workbook opens.

I have just moved it to perform automatic run when the book opens but I get a "complie error" highlighting the me.visible part of the code.

Anyone with any idea's why the code isn't working?

Incidentally, r1 is the current date, and s1 is a preset date - so I need the message box to alert once the current date (r1) has passed teh set date (s1)

Please Login or Register  to view this content.

[JP Romano]

Since you moved it out of some module into "This Workbook" and set it to run when opened, it no longer knows what the ME part of me.visible is. You have to change that back to the name of whatever you're trying to make visible. For example, if you have a form that should pop up and that form is called "UserForm1" then replace me.visible with UserForm1.visible.

[Cheeky Charlie]

^ Almost agree with above except I'd say the insinuation from the hidden values (xlsheetveryhidden) is that the macro was created in a sheet's code and moved (gracelessly?) into the workbook open event. I think replacing all instances of

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

would do it.

CC

[cmb80]

Thanks guys, will give it a bash