Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel macro SHortcut Keys Disappeared and Defaults re appeared

I was using Ctl-P for months to assign protection to sheets in one file i am
developing. I deleted old subroutines from the modules and consolidated all
those macros into one file. All of a sudden the Ctl P does not work but
defaults to Print. The macro assign options box forces me now to Ctl-Shift-P
and acts like Ctl P is assigned, but it is not. Application.onkey works to
reassign.

Two questions
1- How do I get a macro to start and run on worksheet open to define the
keys this way so it just forces the new definitions. I assigned Ctl-z to
force these setups to run but I have employees that used the old sheets and I
cannot add a new step and have to retrain!
2- What happened to the originals? I prefer to FIX the problem than do a
work-around.
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
Macro Shortcut Key Conflicts with Application Shortcut Keys Jordan Hotzel Excel Programming 0 October 13th 06 06:39 AM
Macro Shortcut Key Conflicts with Application Shortcut Keys Jordan Hotzel Excel Programming 0 October 13th 06 06:39 AM
Macro Shortcut Keys Nicolle K. Excel Discussion (Misc queries) 1 January 6th 05 04:55 PM
shortcut macro keys shasta[_6_] Excel Programming 3 April 13th 04 01:57 PM
Macro shortcut keys Diane Garrini Excel Programming 2 July 25th 03 12:29 PM


All times are GMT +1. The time now is 05:42 AM.

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

About Us

"It's about Microsoft Excel"