In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros o

G

Greener

In addition to the previous questions, I wonder, if opening an Excel
file in NON-read-only mode, would the macros on the worksheets work as
well?

Thanks millions!

Helena
 
D

Dave Peterson

I don't know the previous question, but yes, macros will run in update mode.
 
T

Tom Ogilvy

whether the workbook is opened readonly or not has no bearing the macros
working. If you have security set high enough, you will either be prompted,
given the option to disable macros, or they will be disabled automatically.
If macros are not disabled, then you can run them.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Sub projects added as read only in Master file which are saved on sharepoint 1
Embed the same Excel multiple times 0
Open to modify 3
VBA Read-Manipulate-Save Text File 5
Password locked with macro 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
"Following Features Cannot be saved" error on LOADING ?? 1

Top