Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load form when workbook opens
I have this code in a module in my WB:
Private Sub Workbook_Open() frmLTC.Show End Sub Shouldn't this just automatically bring the form up when I open the workbook? Nothing seems to happen, any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load form when workbook opens
Oh duh. I had to put the code inside the workbook, not a module.
(I also thought my code had suddenly stopped working because no records were appearing on the ws - except my ws was showing row 100+ and I only had like 2 records. Duh.) Sorry! "anna" wrote: I have this code in a module in my WB: Private Sub Workbook_Open() frmLTC.Show End Sub Shouldn't this just automatically bring the form up when I open the workbook? Nothing seems to happen, any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load form when workbook opens
Works fine here.
What happens if you put your cursor in that Workbook_Open code and press F5? RBS "anna" wrote in message ... I have this code in a module in my WB: Private Sub Workbook_Open() frmLTC.Show End Sub Shouldn't this just automatically bring the form up when I open the workbook? Nothing seems to happen, any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i double click on an excel file, excel opens but nothing load | Excel Discussion (Misc queries) | |||
Load form when workbook opens | Excel Discussion (Misc queries) | |||
Load VB Code every time Excel opens | Excel Programming | |||
Personal workbook opens when Excel opens | Excel Discussion (Misc queries) | |||
Add-In to load when Excel opens? | Excel Programming |