Help Replacing a Message Box With a Command Button in a Macro

[dgarber]

Hi Everyone,
I am running a WorkbookOpen macro that pops up a Message Box and when the button is clicked proceeds through the macro.
I would like to replace that Message Box with a CommandButton1_Click() button in UserForm1.
I am not sure how or where to insert that in the macro.

Any help would be appreciated!

Thanks,
Dean

Please Login or Register  to view this content.

[Logit]

.
The the body of your macro and paste it into a REGULAR MODULE :

Please Login or Register  to view this content.

Paste a Command Button on the Sheet of your choice and assign it to the above macro .

[dgarber]

Logit,
Thanks for the reply! I probably wasn't specific but what happens is when the Workbook_Open macro runs it tests to see if macro's are enabled. If they are not the MsgBox pops up and clicking
enter "enable macros". If I deactivate the line 'MsgBox "ENTER DSR" then the standard "enable macros" appears in the ribbon. All I want to do is replace the MsgBox popping up with my own command button in a user form.
Thanks,
Dean

[Logit]

.
Kinda confusing precisely what you are seeking. Sorry.

If you create a UserForm1 for your project. On that UserForm1 place a CommandButton. Let's say this button is the first button you have
inserted on the UserForm so it is "CommandButton1".

Right click the button and select VIEW CODE. Paste this in the button code :

Please Login or Register  to view this content.

If the above does not answer your question you'll need to provide additional information.