Locking a Workbook

  • Thread starter Thread starter Patrick Simonds
  • Start date Start date
P

Patrick Simonds

I have a Workbook which has an Auto_Open Macro. The Auto_Open macro displays
a dialogbox which asks "Open as Read Only" or "Edit File". If they select
Open as Read Only I want one of two things. Either make the Workbook Read
Only or disable their ability to save the Workbook.

If they select Edit File, they are asked for a password and then taken into
the Workbook where they are allowed to make and save changes (this part is
working fine).
 
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

Workbook Protection 3
Excel Protection 2
Get calling workbook path? 2
Excel 2013 menubar incompatibility? 1
Auto_Open Code on Worksheet 2
auto open workbook to make read-only 3
security, enabling macros to enable a disabling saving function 12
Unwanted workbooks on startup 2

Back
Top