Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello all,
I have a time sheet template. I have to mail these time sheets in to my supervisor on the 15th and the last day of every month. I have code in the template (and consequently on all timesheets based on this template) that will pop up reminder messages based on the current date in relation to the date the time sheets need to be emailed. What I would like to know is if there is a way to set a constant, like PayPeriodDate, when I create a new file from the template. That way, when I email it to my boss, he won't get the reminder messages popping up on him when he opens it after the Pay Period Ending Date. I also want to use this for some other automated/data entry text boxes that I don't want him to have to deal with. Thanks for any help anyone can provide, Conan Kelly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a row that is constant and updatable across all worksheet | Excel Discussion (Misc queries) | |||
Creating a linked file based on variable location reference | Excel Discussion (Misc queries) | |||
Need Help Creating a Macro to Multiply Cells by a Constant Number | Excel Discussion (Misc queries) | |||
Setting a Constant when creating a new file from a template? | Excel Programming | |||
Can I load text file into Excel seting field delimter using cmd li | Excel Discussion (Misc queries) |