| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to automatically sellect 'No' in dialog box
Hi all! I'm busy creating a macro to automatically update certain values, text and cell formats etc. once it is run. The workbook to be updated, as well as the workbook containing the update values are both password protected. Both workbooks are saved with the option enabled to recommend read-only upon opening them upon which the end-user has the option of selection either 'Yes' or 'No' . I need an entry in my macro that will automatically select the 'No' option, thereby opening the workbook in an editable state. Any help will be appreciated! -- ARbitOUR ------------------------------------------------------------------------ ARbitOUR's Profile: http://www.thecodecage.com/forumz/member.php?userid=254 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=90781 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Dialog Box | Excel Discussion (Misc queries) | |||
| Dialog Box With Macro Buttons (VBA) | Excel Discussion (Misc queries) | |||
| Automatically Close Dialog Boxes | Excel Worksheet Functions | |||
| sellect and sort worksheets by name in excel | Excel Discussion (Misc queries) | |||
| how to use the search dialog via a macro? | Excel Worksheet Functions | |||
![ARbitOUR[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
