Lock Position Of User Form In VBA

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
 
S

SeaparkJohn

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
 
Top