MacDaddy
02-18-2010, 03:50 AM
Morning,
Bit of an odd one is this.
Basically I want to create a status window in an excel file with user information, system information, current date and time connection state to the network and servers etc, but I want this to always be visible while allowing the user to keep full excel and vba functionality.
Rightly or wrongly I've started experimenting with this by opening a form as the workbook opens to display this information but obviously you can't use the rest of excel until the form is closed.
Is there a way of keeping the form open but still allowing excel to be used normally, including the running of macros and switching between worksheets, or is there another way of displaying the status information without using forms.
I've never done anything like this before so it's new territory to me.
Thanks,
Paul
Bit of an odd one is this.
Basically I want to create a status window in an excel file with user information, system information, current date and time connection state to the network and servers etc, but I want this to always be visible while allowing the user to keep full excel and vba functionality.
Rightly or wrongly I've started experimenting with this by opening a form as the workbook opens to display this information but obviously you can't use the rest of excel until the form is closed.
Is there a way of keeping the form open but still allowing excel to be used normally, including the running of macros and switching between worksheets, or is there another way of displaying the status information without using forms.
I've never done anything like this before so it's new territory to me.
Thanks,
Paul