switch off messages?

  • Thread starter Thread starter scottwilsonx
  • Start date Start date
S

scottwilsonx

Hi everyone, I am trying to find a piece of macro that will
automatically open a spreadsheet as read-only without requiring the
user to say "yes" when prompted to open as read-only.

Does anyone know a code that automatically switches off any warning
questions that the user may be prompted for in Excel ?!

Thanks for your help.

Scott.
 
Use
open.worksheet("name.xls"),,true

true makes it open read only
false switches off read onl
 
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

Macro to open a workbook as read only 2
Change To Read Only 1
Open Add-In (.xla) workbook as Read Only automatically 1
Bug in programming - using toggle between read-only and write acce 1
Saving information to PERSONAL.XLS 1
Power plan wont shut off fans after sleep settings 8
Nintendo Switch Review 1
Automatically running an Excel macro on open once only 1

Back
Top