Look into saving the file as an addin
when opened all code works but sheets are not visible to user

for you to view sheets you need to goto VBE windowproperties ISADDIN = false
then make changes and reset to True

"jimbo_jones" wrote:


Hello All,

I am writing an application in Excel VB editor to interface some GPIB
devices for testing and datalogging.

I have writen the code to operate the devices but need help with the
user interface.

How do I make only a userform show when the excel file is opened? I
need to make certain that the user can never alter the spredsheet or
code, what is the best way to deal with this?

Thanks in advance.


--
jimbo_jones
------------------------------------------------------------------------
jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
View this thread: http://www.excelforum.com/showthread...hreadid=467917