Userforms with linked workbook running hidden?

Thomas · May 9th, 2002, 04:44 PM

Hello, all; here's another one I'm butting up against.

I have a series of Userforms that a user enters information into, which is then loaded into an Excel book used as a database. I'd prefer to allow the user to open this more like an application than an Excel book; what would be preferrable is to bring the user forms up while keeping the workbook running them either hidden or minimized, and unable to be accessed.

Thoughts?

Thanks.
~ Thomas

Nimrod · May 9th, 2002, 04:54 PM

I have the user forms in the same workbook as the data. In some situations I just hide the sheet the data is on . Though I've also thought about having a small macro run to unprotect and protect the hidden sheet between users entries.

May 9th, 2002, 04:54 PM	#2
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	I have the user forms in the same workbook as the data. In some situations I just hide the sheet the data is on . Though I've also thought about having a small macro run to unprotect and protect the hidden sheet between users entries. __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 04:44 PM	#1
Thomas Board Regular Join Date: May 2002 Location: Dallas Posts: 365	Hello, all; here's another one I'm butting up against. I have a series of Userforms that a user enters information into, which is then loaded into an Excel book used as a database. I'd prefer to allow the user to open this more like an application than an Excel book; what would be preferrable is to bring the user forms up while keeping the workbook running them either hidden or minimized, and unable to be accessed. Thoughts? Thanks. ~ Thomas