Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
i have sort of created a very simple user form in excel and put a little vba
code in it. When i try running it, it comes up with a screen to do with macros. Does this mean I need macros just to even preview what the form would look like on its own? And if I do, how do I go about doing this? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
During development phase, if your cursor is in any sub or function of the
userform. such as CommandButton1_Click your macro should run when you click the run button on the toolbar. Later add the line UserForm1.Show to the Workbook_open sub. Private Sub Workbook_Open() UserForm1.Show End Sub Now the userform will open whenever you open the workbook, or during development place the cursor in this sub before clicking the run button. "bunmi" wrote: i have sort of created a very simple user form in excel and put a little vba code in it. When i try running it, it comes up with a screen to do with macros. Does this mean I need macros just to even preview what the form would look like on its own? And if I do, how do I go about doing this? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macros
You really should include the wording in "the little screen" but anyway, yes,
in order to run macros you must have Tools, Macro, Security, [x] Medium Each time you open a file you will get a warning that the workbook has macros "Macros may contain viruses, ... " To which you reply with "Enable Macros" if you are familiar with the workbook and want to run macros; otherwise, "Disable Macros" and you can look at the macros, but not run them. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "bunmi" wrote... i have sort of created a very simple user form in excel and put a little vba code in it. When i try running it, it comes up with a screen to do with macros. Does this mean I need macros just to even preview what the form would look like on its own? And if I do, how do I go about doing this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
weird saving of a document with macros resulting with macros being transfered to the copy | Excel Programming | |||
Macros inside macros, and pasting into macro code. | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
convert lotus 123w macros to excel macros | Excel Programming | |||
Macro Size Limit / open macros with macros? | Excel Programming |