toolbars and customs view

[Guest]

I have created a simple program in Excel. I want to give this program to some firends. However, I don't want them to be able to open the macro files How do I do that

Then when they open the program, I want the view to remove all columns, rows, formula bar and even the toolbar and display on the top of the window my customized toolbar

How do I do all these. Thanks for your help.

 

[Earl Kiosterud]

Roy,

The macros are stored in the workbook file. If you want them to run, but
not be visible, the macros can be secured (to the extent that Excel can
secure anything, and it isn't much) with Tools - VBA Project Properties -
Protection - Lock project for viewing. Supply a password. Don't lose it.
It might take you 15 minutes to get it cracked if you do.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

I have created a simple program in Excel. I want to give this program to

some firends. However, I don't want them to be able to open the macro files
How do I do that.

Then when they open the program, I want the view to remove all columns,

rows, formula bar and even the toolbar and display on the top of the window
my customized toolbar.

 

[Guest]

Thanks Earl. Any ideas on the other questions?

 

[Earl Kiosterud]

Roy,

Record a macro while manually doing all that stuff.