If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
HELP: Mouse Pointer Changes When Sheet Protected
A user of mine has a multiple sheet workbook. When he protects two of the
sheets, the mouse pointer changes from the 'puffy white cross' (selection mouse) to the 'pointing hand' (hyperlink mouse). On all the other sheets when he protects, the mouse stays a selection mouse. I've done some trouble shooting - here's what I know to be true: There are three simple macros on the sheet, but all the sheets have similar macros. These macros jump between sheets in the workbook. The code is a simple select sheet and then go to A1. When I copy the sheet (Select Sheet, Copy) and paste to a new workbook and protect, the mouse stays as a selection mouse. (note the macros do not copy over this way.) If anyone has seen this before or can help, I'd appreciate it. Cheers, Gillian |
#2
|
|||
|
|||
Not sure about the problem, but you don't need macros to go to another
sheet. Hyperlinks will do it just as well. ************ Anne Troy www.OfficeArticles.com "GillianHG" wrote in message ... A user of mine has a multiple sheet workbook. When he protects two of the sheets, the mouse pointer changes from the 'puffy white cross' (selection mouse) to the 'pointing hand' (hyperlink mouse). On all the other sheets when he protects, the mouse stays a selection mouse. I've done some trouble shooting - here's what I know to be true: There are three simple macros on the sheet, but all the sheets have similar macros. These macros jump between sheets in the workbook. The code is a simple select sheet and then go to A1. When I copy the sheet (Select Sheet, Copy) and paste to a new workbook and protect, the mouse stays as a selection mouse. (note the macros do not copy over this way.) If anyone has seen this before or can help, I'd appreciate it. Cheers, Gillian |
#3
|
|||
|
|||
More troubleshooting - I deleted all the macros from the workbook and the
buttons but no change to the issue. Also, wherever the active cell is, when I protect, I am unable to click on another cell - it's like the active cell stays frozen. However, I can use my keyboard to move the active cell. I checked the Protection settings and I have Select Locked Cells and Select Unlocked Cells active. Again, your help is appreciated. -- Thanks, GillianHG "Anne Troy" wrote: Not sure about the problem, but you don't need macros to go to another sheet. Hyperlinks will do it just as well. ************ Anne Troy www.OfficeArticles.com "GillianHG" wrote in message ... A user of mine has a multiple sheet workbook. When he protects two of the sheets, the mouse pointer changes from the 'puffy white cross' (selection mouse) to the 'pointing hand' (hyperlink mouse). On all the other sheets when he protects, the mouse stays a selection mouse. I've done some trouble shooting - here's what I know to be true: There are three simple macros on the sheet, but all the sheets have similar macros. These macros jump between sheets in the workbook. The code is a simple select sheet and then go to A1. When I copy the sheet (Select Sheet, Copy) and paste to a new workbook and protect, the mouse stays as a selection mouse. (note the macros do not copy over this way.) If anyone has seen this before or can help, I'd appreciate it. Cheers, Gillian |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
is it possible to use macros when the sheet is protected | Dajana | General Discussion | 1 | September 23rd, 2005 03:08 AM |
Copying multiple sheets from one book 2 another and undertake spec | Pank Mehta | General Discussion | 14 | March 16th, 2005 04:41 PM |
How do i enable "Group" & "Ungroup" in a protected sheet | Fadi | General Discussion | 1 | March 4th, 2005 05:37 PM |
Spell check on a protected sheet | jontait | General Discussion | 2 | October 28th, 2004 06:52 PM |
Mouse Pointer Stuck | Greg Boll | Worksheet Functions | 2 | March 9th, 2004 08:53 PM |