Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 19th 07, 12:16 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2
Default 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.

  #2   Report Post  
Old December 19th 07, 04:44 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default 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.


  #3   Report Post  
Old December 19th 07, 05:06 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Dec 2007
Posts: 2
Default 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.



  #4   Report Post  
Old December 20th 07, 02:27 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 897
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cursor Placement Adrienne New Users to Excel 2 November 3rd 07 03:15 PM
Cursor movement in a macro Kanga Excel Discussion (Misc queries) 3 January 11th 07 02:10 AM
Controlling Cell/Cursor Placement MarkT Excel Discussion (Misc queries) 3 August 17th 05 02:54 PM
Cursor placement Randy New Users to Excel 1 July 11th 05 02:01 PM
Start/run a macro from wherever the cursor is??? HELP! trixiebme Excel Worksheet Functions 1 March 22nd 05 07:14 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017