ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well? (https://www.excelbanter.com/excel-programming/279089-addition-previous-question-if-opening-excel-file-non-read-only-mode-would-macros-worksheets-work-well.html)

Greener

In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well?
 
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

Dave Peterson[_3_]

In addition to previous question, if opening an Excel file inNON-read-only mode, would the macros on the worksheets work as well?
 
I don't know the previous question, but yes, macros will run in update mode.

Greener wrote:

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


--

Dave Peterson


Tom Ogilvy

In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well?
 
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.

--
Regards,
Tom Ogilvy

Greener wrote in message
om...
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





All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com