Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Popup on Opening of a Spreadsheet
Good Day,
I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet. (I have a second sheet that provides directions but, I would like to emphasize a couple points. I hope this is a feature within Excel but, I wouldnt be surprised if I need to use VBA code to make it happen. Any suggestions, would be greatly appreciated. Thanks, Brad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Popup on Opening of a Spreadsheet
I dont know if this is a feature within excel, but if you want to fit a
fair bit of information on the 'pop-up' screen then I would use vba, create a userform and just put all the information on it that you want people to see, in the workbook_open put "userform1.show" , on the userform you will need to include a "close" or "finish" button to get rid of the form and behind the button all you need is "unload userform1" so not much vba code really but again, i dont know if this is a feature of excel already HTH Duncan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Popup on Opening of a Spreadsheet
Thank You Duncan,
Your help is appreciated. Regards, Brad "Duncan" wrote: I dont know if this is a feature within excel, but if you want to fit a fair bit of information on the 'pop-up' screen then I would use vba, create a userform and just put all the information on it that you want people to see, in the workbook_open put "userform1.show" , on the userform you will need to include a "close" or "finish" button to get rid of the form and behind the button all you need is "unload userform1" so not much vba code really but again, i dont know if this is a feature of excel already HTH Duncan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Popup on Opening of a Spreadsheet
You can have comments in cells that pop up. You can set validation in cells
which includes a pop up. But there is no workbook level popup capability inherent in Excel. You can use VBA code to put up a "splash screen" John Walkenbach shows one way: http://www.j-walk.com/ss/excel/tips/tip39.htm -- Regards, Tom Ogilvy "Brad.R.Sutton" wrote: Good Day, I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet. (I have a second sheet that provides directions but, I would like to emphasize a couple points. I hope this is a feature within Excel but, I wouldnt be surprised if I need to use VBA code to make it happen. Any suggestions, would be greatly appreciated. Thanks, Brad |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automated Popup on Opening of a Spreadsheet
Thank You Tom,
This definately helped. Best Regards, Brd "Tom Ogilvy" wrote: You can have comments in cells that pop up. You can set validation in cells which includes a pop up. But there is no workbook level popup capability inherent in Excel. You can use VBA code to put up a "splash screen" John Walkenbach shows one way: http://www.j-walk.com/ss/excel/tips/tip39.htm -- Regards, Tom Ogilvy "Brad.R.Sutton" wrote: Good Day, I would like a popup screen to come up automatically when a spreadsheet is open. This popup will provide directions to the users of the spreadsheet. (I have a second sheet that provides directions but, I would like to emphasize a couple points. I hope this is a feature within Excel but, I wouldnt be surprised if I need to use VBA code to make it happen. Any suggestions, would be greatly appreciated. Thanks, Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Popup opening a spreadsheet | Excel Programming | |||
automated spreadsheet | Excel Programming | |||
Automated spreadsheet Consolidation | Excel Programming | |||
Automated userform inputs to the spreadsheet | Excel Programming | |||
Automated userform inputs to the spreadsheet | Excel Programming |