Allowing only one or two viewings of a worksheet?

R

Ryan

I have made a macro that only allows a viewer to view a worksheet I've sent them once or twice, but I need to send it to someone who cannot run macros. Is there a non-vb way to only allow a person to view a worksheet once or twice (to clarify I want to send a sample sheet that will not be passed around).
 
G

Grey Newt

Nope - not without some form of programming
The best way is to use a simple event macro behind the sheet that counts the number of times the sheet is opened - and when a set number is reached - it hides the sheet (idealy using xlveryhidden so the user cannot unhide it
This is simple to write and does not require any interaction from the user
 
Top