Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
2 Questions
1. I have a file with some cells are protected and some that are not. When I protect the worksheet I can not use the arrows on the keyboard to move up and down through the non-protected cells, but the left and right arrows still work. Everything works when the sheet is not protected. 2. I have I file that asks to Enable or Disable Macros when the file opens, but there are no marco in the file. I tried removing the all modules and all but the one sheet that I need per this site: http://www.contextures.com/xlfaqMac.html#NoMacros. It still asks and I can not seem to remove this code Private Sub Worksheet_SelectionChange(ByVal Target As Range) End Sub out of the Workbook -- SelecionChange When I delete it the drop down box changes on its own to (General) and then the code stays there. Thanks in advance for any help offered. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to enable a macro in protected sheet | Excel Discussion (Misc queries) | |||
How do I enable my mouses Horizontal Scroll in Excel 2007 | Excel Discussion (Misc queries) | |||
remove enable macro prompt | Excel Discussion (Misc queries) | |||
enable commentaries when is protected | Excel Worksheet Functions | |||
MACRO QUES FOR MVP | Excel Discussion (Misc queries) |