Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Protection UserInterfaceOnly reading Hidden Formulas

Can someone please confirm that even with protection
UserInterfaceOnly:=True set for a worksheet, I still
cannot read or use replace method with cells that are set
hidded. I currently have to completely unprotect the
sheet or leave the cells un-hidded... I don't like either
of these options, because the users either see the
formulas or the sheet would be unprotected if the code
pukes...

Anythoughts?!?
-Rik

Read
CellVal = Worksheets("sheet1").Range("U2").Formula
Replace
Worksheets("sheet1").Range("A1:AI164").Replace _
What:="Template", Replacement:=""

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,824
Default Protection UserInterfaceOnly reading Hidden Formulas

If the rows are hidden as a result of an autofilter, then replace won't find
them. The same thing happens when you do it manually.

Maybe you can unfilter, do your change and refilter?

or if the number of cells is small, loop through them and use the replace
function (or application.substitute if you're using xl97).

Rik Ditter wrote:

Can someone please confirm that even with protection
UserInterfaceOnly:=True set for a worksheet, I still
cannot read or use replace method with cells that are set
hidded. I currently have to completely unprotect the
sheet or leave the cells un-hidded... I don't like either
of these options, because the users either see the
formulas or the sheet would be unprotected if the code
pukes...

Anythoughts?!?
-Rik

Read
CellVal = Worksheets("sheet1").Range("U2").Formula
Replace
Worksheets("sheet1").Range("A1:AI164").Replace _
What:="Template", Replacement:=""


--

Dave Peterson

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
reading data from hidden sheet Atiq Excel Discussion (Misc queries) 4 January 27th 10 09:14 PM
UserInterfaceOnly & Password Protection D.Parker Excel Discussion (Misc queries) 6 October 9th 07 09:46 PM
How to keep hidden columns hidden using protection Dave Excel Discussion (Misc queries) 1 March 1st 06 03:20 AM
worksheet protection reading neeraj New Users to Excel 7 September 21st 05 07:13 AM
formulas are reading weird darcerella Excel Worksheet Functions 3 December 1st 04 09:46 AM


All times are GMT +1. The time now is 12:33 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"