View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Grey Newt Grey Newt is offline
external usenet poster
 
Posts: 16
Default Allowing only one or two viewings of a worksheet?

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