Cursor placement without Macro/VBA
I have an Excel file with 5 sheets that I need to email to a large group of
people, and would like the cursor to go a specific cell everytime a person clicks on a sheet. Is there a way to do this without using a macro/vba since the email may be blocked becasue the Excel contains macros. I look forward to suggestions. |
Cursor placement without Macro/VBA
Sorry, no way that I know of. You could use the Worksheet_Activate
event for the worksheet. ps- What email program are you using that would be able to check inside a workbook attachment for macros? HTH, JP On Dec 18, 6:16 pm, dwiba wrote: I have an Excel file with 5 sheets that I need to email to a large group of people, and would like the cursor to go a specific cell everytime a person clicks on a sheet. Is there a way to do this without using a macro/vba since the email may be blocked becasue the Excel contains macros. I look forward to suggestions. |
Cursor placement without Macro/VBA
Thanks JP,
We have had clients tell us that their email and servers have blocked the files. "JP" wrote: Sorry, no way that I know of. You could use the Worksheet_Activate event for the worksheet. ps- What email program are you using that would be able to check inside a workbook attachment for macros? HTH, JP On Dec 18, 6:16 pm, dwiba wrote: I have an Excel file with 5 sheets that I need to email to a large group of people, and would like the cursor to go a specific cell everytime a person clicks on a sheet. Is there a way to do this without using a macro/vba since the email may be blocked becasue the Excel contains macros. I look forward to suggestions. |
Cursor placement without Macro/VBA
It might not be the file, it might their administrator's policy to
block certain files. Also you may want to review this: http://support.microsoft.com/kb/938810 HTH, JP On Dec 19, 11:06 am, dwiba wrote: Thanks JP, We have had clients tell us that their email and servers have blocked the files. |
All times are GMT +1. The time now is 02:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com