Allowing only one or two viewings of a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine multiple worksheets in one Workbook into one big worksheet 6
Enable autofilter in protected worksheets in Excel 2000 6
Combining Multilple Worksheets Into One 6
Views available to the entire workbook, not just 1 worksheet 2
Password protection worksheet 1
Macro to open view with a password 3
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Novice q: allow user to select worksheet in middle of macro 3

Back
Top