how to test code and/or run code

[Danny]

I would like to:
test the code or button that I inserted with code on spreadsheet.

allow the user to launch the spreadsheet in run mode.

(newbie)
how to do?

 

[Dave Peterson]

Before you turn over your workbook to your users, you'll want to test your code.

Click the button to start the macro.

You may want to insert some breakpoints in your code so that you can Step
through it.

Select a line in your code that does something (not a Dim) and hit F9
(Debug|toggle breakpoint).

If it was an ok line, you'll see a red dot on the left border and the line will
be shaded red.

When your running code gets to this line, it'll stop and wait for you. Hit F8
to go line by line through the code.

I'm not sure what your second question is. If the user allows macros to be run
(his/her choice--not yours), then they can click the button.