I have the following macro that works on excel 2003 but it doesn't work on 2010. I lower the macro security levels thinking that was the problem but I think it has to be the sintax on 2010 and VBA.
Thanks in advance fo your help.
Please Login or Register to view this content.
Last edited by arlu1201; 05-23-2012 at 02:00 PM. Reason: Use code tags in future.
The only thing I could find breaking it was the protection. After moving it to the bottom it worked fine. However, you could shorten and simplify the code a bit:
Please Login or Register to view this content.
It works great.
There' one more thing. I have to start with an unprotected sheet otherwise the macros won't work.
I have the same button for every day of the week, so let's say the condition is "yes" for Monday, the macro executes but it locks the sheet and then the other days of the week won't work, is there a way around this?
I really appreciate your help!
I would like to add that the active sheet needs to be protected in order to avoid tampering with formulas
So, how do you know which day of the week you want to protect/unprotect?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks