ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   change cellpointer (https://www.excelbanter.com/excel-discussion-misc-queries/181132-change-cellpointer.html)

joelberns

change cellpointer
 
how can one change the standard cellpointer cross of a spreadsheet to an
arrow that remains an arrow everywhere in the spreadsheet

Tom Hutchins

change cellpointer
 
Paste this code in the ThisWorkbook module of the workbook:

Private Sub Workbook_Activate()
Application.Cursor = xlNorthwestArrow
End Sub

Private Sub Workbook_Deactivate()
Application.Cursor = xlDefault
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Hope this helps,

Hutch

"joelberns" wrote:

how can one change the standard cellpointer cross of a spreadsheet to an
arrow that remains an arrow everywhere in the spreadsheet



All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com