| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Event macro does not run a Private sub
Excel XP & Win XP
I have a simple BeforeSave macro: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Call UpdateAll End Sub The UpdateAll macro is a Private macro as: Private Sub UpdateAll() 'Stuff End Sub The event macro errored out as not being able to find the sub. When I removed the "Private" in the first line of the UpdateAll macro, it worked fine. Why is that? Thanks for your time. Otto |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Improve method of calling a private function in a private module | Excel Programming | |||
| Private Sub Workbook_Open() event won't fire if workbook is hidden? | Excel Programming | |||
| Public, Private, Event modules, Forms modules,,, | Excel Programming | |||
| re : Possible to run private sub macros by writing another private | Excel Programming | |||
| Private Sub Running Other Private Sub Inadvertently | Excel Programming | |||
![Otto Moehrbach[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
