LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Jim Rech
 
Posts: n/a
Default

Is there a way to do this and still not have to change my macros.

I think you will have to change your macro so that it unprotects the
worksheet, does the copy/paste and re-protects the worksheet.

--
Jim
"Dajana" wrote in message
...
|I trying to copy/past info from one sheet to another that is protected.
| However even though the info copies into the sheet I have to debug my
macros
| for some reason since it always takes me automatically to the VB page. I
| would not like to have to use password that the user needs to enter every
| time he tries to copy/paste info nor would I like to define users that
will
| be able to do that since I don't know who will be using the document. Is
| there a way to do this and still not have to change my macros.
|
| Thanks


 
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
List, Data Validation, unlocked cell, protected sheet..... Kane New Users to Excel 6 July 16th 12 09:11 AM
Tab key don't work in unprotected cells in a protected sheet Chad Excel Discussion (Misc queries) 0 August 16th 05 02:00 AM
If Info. from one Sheet matches, send it to another sheet Slava Excel Discussion (Misc queries) 1 June 21st 05 06:36 PM
What is the shorcut key for moving between protected sheet? Rao Ratan Singh Excel Discussion (Misc queries) 1 May 6th 05 04:46 PM
allwoing protected excell sheet darshan Excel Worksheet Functions 0 February 17th 05 01:49 PM


All times are GMT +1. The time now is 12:38 AM.

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

About Us

"It's about Microsoft Excel"