I have a macro button on my worksheet that does as follows
-unhides hidden cells
-selects print area
- sets to print portrait
-prints 2 copies
-re hides cells
-protects sheet
The problem is I cannot run macro because my sheet is allready protected.Is there code I can put in to unprotect first when I click Button.Would appreciate it if anybody can help.Thanks Ben my code is as follows
Please Login or Register to view this content.
Bookmarks