Lock Position Of User Form In VBA

  • Thread starter Thread starter Celtic_Avenger
  • Start date Start date
C

Celtic_Avenger

Can Someone Help?


Ron De Bruin and Jorge Rodrigues gave sone ideas on how to disable th
"X" close button on a user form.

However I now need to ensure that the User Form cant be moved down b
holding on the program bar and sliding down, as this would revea
critical data shown below.

Is there a way to lock the position of the User Form?

Thanks

Celtic_Avenge
 
While I'm not aware of a way to lock the postion of a user form, one way to
protect the data would be to color the font the same as the background color
of the spreadsheet, making it invisible. then lock the spreadsheet so that
it cannot be used
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

User Forms - Tips needed to get started 3
Lock a form 3
Embedding spreadsheet in a user form 3
"Lock" position of text in document 1
Random Locking of form fields during fill in 0
Controlling position of query window 1
Disable Close "X" button on User Forms 2
Form Position Option 6

Back
Top