Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to comp.lang.javascript,comp.lang.java.javascript,microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default 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
  #2   Report Post  
Posted to comp.lang.javascript,comp.lang.java.javascript,microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default 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

  #3   Report Post  
Posted to comp.lang.javascript,comp.lang.java.javascript,microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XLS files opening as Read-Only Repaired Compatibility mode CindyInTexas Excel Discussion (Misc queries) 0 September 4th 08 07:36 PM
How do I stop a Excel 2007 file opening as read only? Will Excel Discussion (Misc queries) 0 September 1st 08 10:03 AM
How do I stop a Excel 2007 file opening as read only? Will Excel Discussion (Misc queries) 1 August 31st 08 11:14 PM
enable macros question not being asked when opening file Aussie Ells Excel Discussion (Misc queries) 1 June 7th 07 04:05 AM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. Tim Marsden Charts and Charting in Excel 2 October 15th 05 02:10 PM


All times are GMT +1. The time now is 09:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"