Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
I have an auto_close macro designed to reset toolbars etc.
once a user has finished with the workbook. Is it possible to prevent users being able to run the macro whilst the workbook is in use? Many Thanks Paul Moles PS The code is protected using project properties, I am trying to stop premature running. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
Use the workbook_beforeclose event instead.
http://www.cpearson.com/excel/events.htm Regards, Tom Ogilvy Paul Moles wrote in message ... I have an auto_close macro designed to reset toolbars etc. once a user has finished with the workbook. Is it possible to prevent users being able to run the macro whilst the workbook is in use? Many Thanks Paul Moles PS The code is protected using project properties, I am trying to stop premature running. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
Correct, the user cannot run workbook_beforeclose. But have you ever
wondered why a user *can* run workbook_open directly from the VBE? "Tom Ogilvy" wrote in message ... Use the workbook_beforeclose event instead. http://www.cpearson.com/excel/events.htm Regards, Tom Ogilvy Paul Moles wrote in message ... I have an auto_close macro designed to reset toolbars etc. once a user has finished with the workbook. Is it possible to prevent users being able to run the macro whilst the workbook is in use? Many Thanks Paul Moles PS The code is protected using project properties, I am trying to stop premature running. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
I always assumed it was because Workbook_Open() has no arguments.
You can certainly run this from the VBE: Public Sub try() Workbook_BeforeClose True End Sub In article , (onedaywhen) wrote: Correct, the user cannot run workbook_beforeclose. But have you ever wondered why a user *can* run workbook_open directly from the VBE? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
Use the Workbook_BeforeClose event
Private Sub Workbook_BeforeClose(Cancel As Boolean) auto_close macro here End Sub Lars Kofod -----Original Message----- I have an auto_close macro designed to reset toolbars etc. once a user has finished with the workbook. Is it possible to prevent users being able to run the macro whilst the workbook is in use? Many Thanks Paul Moles PS The code is protected using project properties, I am trying to stop premature running. . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unauthorised Use Of Macro
Hi Paul
What if the user want to have several open files simoultaneously ? I'd expect my toolbars to look and work as always when I'm in the not-your-workbooks. Consider to use the activate / deactivate events instead. Paste this in the ThisWorkbook module: Private Sub Workbook_WindowActivate(ByVal Wn As Window) MsgBox "Active" End Sub Private Sub Workbook_WindowDeactivate(ByVal Wn As Window) MsgBox "Gone" End Sub -- HTH. Best wishes Harald Followup to newsgroup only please. "Paul Moles" wrote in message ... I have an auto_close macro designed to reset toolbars etc. once a user has finished with the workbook. Is it possible to prevent users being able to run the macro whilst the workbook is in use? Many Thanks Paul Moles PS The code is protected using project properties, I am trying to stop premature running. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Protect macro for unauthorised use | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |