S
Steve Jones
Hi
I am trying to create a workbook which I would like to leave open 24 hours a
day, seven days a week.
The worksheet is button operated. I have protected objects, cells with
passwords, disabled formula bars etc.Is there any way that I can make the
menu bar inoperative and also stop the workbook being closed? I don't want
the users to operate anything else but the buttons.
I have created "application.ontime" to run at a certain time. If I run the
code manually it works, how can I get the code to run at say 08.00hrs
everyday if the program is always on?
Thanks very much
Steve
I am trying to create a workbook which I would like to leave open 24 hours a
day, seven days a week.
The worksheet is button operated. I have protected objects, cells with
passwords, disabled formula bars etc.Is there any way that I can make the
menu bar inoperative and also stop the workbook being closed? I don't want
the users to operate anything else but the buttons.
I have created "application.ontime" to run at a certain time. If I run the
code manually it works, how can I get the code to run at say 08.00hrs
everyday if the program is always on?
Thanks very much
Steve