Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to figure out a way to have a box w/ text appear every time
a spreadsheet is opened. I am distributing this spreadsheet to a lot of people. They will not need to enter data but I want to provide clarifying information. I did this with a macro and it worked great except that all of the computers in my company have their securtiy setting at high so the macro won't work. Is there a way around this or another way to make some form of a text box appear without it being a macro? Thank you! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
japc90, best to stay with the original post, how about adding a sheet with
your "clarifying information" on it, save the workbook with that sheet active and they will see it when the workbook is opened, or add a text box to your sheet with your info in it. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "japc90" wrote in message oups.com... I am trying to figure out a way to have a box w/ text appear every time a spreadsheet is opened. I am distributing this spreadsheet to a lot of people. They will not need to enter data but I want to provide clarifying information. I did this with a macro and it worked great except that all of the computers in my company have their securtiy setting at high so the macro won't work. Is there a way around this or another way to make some form of a text box appear without it being a macro? Thank you! |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks again. It is always the simplest answers that elude me.
Paul B wrote: japc90, best to stay with the original post, how about adding a sheet with your "clarifying information" on it, save the workbook with that sheet active and they will see it when the workbook is opened, or add a text box to your sheet with your info in it. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "japc90" wrote in message oups.com... I am trying to figure out a way to have a box w/ text appear every time a spreadsheet is opened. I am distributing this spreadsheet to a lot of people. They will not need to enter data but I want to provide clarifying information. I did this with a macro and it worked great except that all of the computers in my company have their securtiy setting at high so the macro won't work. Is there a way around this or another way to make some form of a text box appear without it being a macro? Thank you! |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks again. It is always the simplest answers that elude me.
Paul B wrote: japc90, best to stay with the original post, how about adding a sheet with your "clarifying information" on it, save the workbook with that sheet active and they will see it when the workbook is opened, or add a text box to your sheet with your info in it. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "japc90" wrote in message oups.com... I am trying to figure out a way to have a box w/ text appear every time a spreadsheet is opened. I am distributing this spreadsheet to a lot of people. They will not need to enter data but I want to provide clarifying information. I did this with a macro and it worked great except that all of the computers in my company have their securtiy setting at high so the macro won't work. Is there a way around this or another way to make some form of a text box appear without it being a macro? Thank you! |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks again. It is always the simplest answers that elude me.
Paul B wrote: japc90, best to stay with the original post, how about adding a sheet with your "clarifying information" on it, save the workbook with that sheet active and they will see it when the workbook is opened, or add a text box to your sheet with your info in it. -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "japc90" wrote in message oups.com... I am trying to figure out a way to have a box w/ text appear every time a spreadsheet is opened. I am distributing this spreadsheet to a lot of people. They will not need to enter data but I want to provide clarifying information. I did this with a macro and it worked great except that all of the computers in my company have their securtiy setting at high so the macro won't work. Is there a way around this or another way to make some form of a text box appear without it being a macro? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro security | Excel Discussion (Misc queries) | |||
Macro security | New Users to Excel | |||
Macro Security | Excel Discussion (Misc queries) | |||
How do I record a macro which should work on multiple files ? | Excel Discussion (Misc queries) | |||
Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) |