Remove UserForm Borders and Close X

[HangMan]

I am trying to remove the Borders and Close Box from a UserForm so I can use it as a splash Screen.

I have used the code suggested by Leith Ross

http://www.excelforum.com/excel-prog...m-borders.html

however, although this works, when the spreadsheet launches, the UserForm displays WITH the Border and Close box for about a second before then disappearing!

Is there any obvious reason why this would happen?


I am using Excel 2007/2010 under Windows 7.

[Leith Ross]

Hello hangman,

The UserForm is created first based on the VBA class design. The macro code waits until the UserForm is displayed, to obtain the window handle, and modifies it. Why your in a loop, I can only guess. You need to post your workbook or the code.

[HangMan]

Hi Leith

Fixed the looping problem...

If I've read you correctly, this means there is no way around the border momentarily displaying before disappearing?

[Leith Ross]

Hello hangman,

On all my computers, this have never been an issue. You can try the code below and see if that helps. Change UerForm1 to the name of your user form.

Please Login or Register  to view this content.

[HangMan]

Leith

Thanks for that, however it made no difference, still have the border showing for a good 1 second prior to it disappearing... Strange.

[Leith Ross]

Hello HangMan,

If it appears for a 1 second or so then you are probably low on RAM. You may need to reduce the number of programs that are running.

[HangMan]

Thanks Leith Ross. Looks as though you were right, a re-boot seemed to have fixed the problem.

Many thanks for your help, greatly appreciated - all working perfectly now.