| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
switch off messages?
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. -- scottwilsonx ------------------------------------------------------------------------ scottwilsonx's Profile: http://www.excelforum.com/member.php...o&userid=11128 View this thread: http://www.excelforum.com/showthread...hreadid=270745 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
switch off messages?
Use open.worksheet("name.xls"),,true true makes it open read only false switches off read onl -- ianrippin ----------------------------------------------------------------------- ianripping's Profile: http://www.excelforum.com/member.php...nfo&userid=320 View this thread: http://www.excelforum.com/showthread.php?threadid=27074 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Messages | Excel Worksheet Functions | |||
| Not getting messages in OE | Excel Worksheet Functions | |||
| Msg.box -messages | Excel Discussion (Misc queries) | |||
| Pop up messages | Excel Programming | |||
| Messages not available | Excel Programming | |||
![scottwilsonx[_59_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
