Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Open help
Hi...
I'm opening a template. The new sheet requires the user to input a name 9using an input box) that the new spreadsheet will be called. This must happen so that if the sheet is used several times, the user will not have to enter this information again (it must only be the one time, when it spins away from the template). The sheet auto saves on closure. I can't get my mind around it. Any help gratefully received. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Open help
Maybe just checking to see if that cell is empty would be sufficient:
Option Explicit sub auto_open() dim myCell as range set mycell = thisworkbook.worksheets("Sheet1").range("a1") if isempty(mycell) then mycell.value = inputbox(Prompt:="Your name is...") end if end sub Gordon wrote: Hi... I'm opening a template. The new sheet requires the user to input a name 9using an input box) that the new spreadsheet will be called. This must happen so that if the sheet is used several times, the user will not have to enter this information again (it must only be the one time, when it spins away from the template). The sheet auto saves on closure. I can't get my mind around it. Any help gratefully received. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Open | Excel Programming | |||
open up an excel program with an auto open macro | Excel Programming | |||
Auto Open | Excel Discussion (Misc queries) | |||
auto open, auto close | Excel Programming | |||
Auto Open | Excel Programming |