Cursor placement without Macro/VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dwiba - 18 Dec 2007 23:16 GMT

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.

Reply to this Message

JP - 19 Dec 2007 15:44 GMT

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

> 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.

Reply to this Message

dwiba - 19 Dec 2007 16:06 GMT

Thanks JP,

We have had clients tell us that their email and servers have blocked the
files.

> Sorry, no way that I know of. You could use the Worksheet_Activate
> event for the worksheet.
[quoted text clipped - 11 lines]
> >
> > I look forward to suggestions.

Reply to this Message

JP - 20 Dec 2007 13:27 GMT

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

> Thanks JP,
>
> We have had clients tell us that their email and servers have blocked the
> files.

Reply to this Message

Rate this thread: