Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coupla questions
Hi there,
Q1. When I force run the following code: Sub workbook_before_close() Call Show_Welcome Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Visible = (ws.Name < "Welcome") * -1 - 1 Next ws Application.SaveWorkspace End Sub I get a dialogue saying "A file named "Resume.XLW" already exists in the location. Do you want to replace it?" What does this mean, and how would I auto-replace file without user intervention? Q2. What is to stop someone, once macros are enabled to go to Tools|Macro|Macros| then deleting or running whatever they want? Q3. Is there a global routine that will prevent anybody from saving through any method, whether it be a dialogue prompt, the save button in the toolbar, or through File|Save/Save As? Thanks for your time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coupla questions
Hi
try: Sub workbook_before_close() Call Show_Welcome Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Visible = (ws.Name < "Welcome") * -1 - 1 Next ws application.displayalerts=false Application.SaveWorkspace application.displayalerts=true End Sub -- Regards Frank Kabel Frankfurt, Germany "Rich" schrieb im Newsbeitrag om... Hi there, Q1. When I force run the following code: Sub workbook_before_close() Call Show_Welcome Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Visible = (ws.Name < "Welcome") * -1 - 1 Next ws Application.SaveWorkspace End Sub I get a dialogue saying "A file named "Resume.XLW" already exists in the location. Do you want to replace it?" What does this mean, and how would I auto-replace file without user intervention? Q2. What is to stop someone, once macros are enabled to go to Tools|Macro|Macros| then deleting or running whatever they want? Q3. Is there a global routine that will prevent anybody from saving through any method, whether it be a dialogue prompt, the save button in the toolbar, or through File|Save/Save As? Thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
questions about at sum | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
3 Questions actually! | Excel Discussion (Misc queries) | |||
A few RTD Questions | Excel Programming |