I have a workbook that is locked except for everything except viewing.. how do i allow for printing though?

[kbishop94]

Workbook is locked to limit anyone changing anything on it or anything else, other than viewing it. But, I do have 4 command buttons onthe worksheet. One is for printing the worksheet, 1 for zooming in, 1 for zooming out, and the last one for resetting the zoom so that it fillsthe screen.
With the workbook being locked, when you click on either of the command buttons, you (obviiously) get an error. What code do I need to insert so that it allows the functions each command button executes when selected? Thanks!

 

[Ruddles]

Sounds like you need to unprotect the sheet before your code does anything, then protect it again afterwards. Can it be as simple as that or have I misunderstood the question?

Googling excel vba protect unprotect should give you a clue (mrexcel.com was second in the search results when I did this), or you could start the Macro Recorder, unprotect and protect manually, then see what code is generated.

 

[kbishop94]

Sounds like you need to unprotect the sheet before your code does anything, then protect it again afterwards. Can it be as simple as that or have I misunderstood the question?

Googling excel vba protect unprotect should give you a clue (mrexcel.com was second in the search results when I did this), or you could start the Macro Recorder, unprotect and protect manually, then see what code is generated.

Perfect! Thank you, Ruddles