Search results for query: *

Wondering if anyone can help. Have searched through and struggling to find this. Going through some old proformas removing copy / paste values in the code and replacing with application.range("X") = application.range("Y").value to speed them up. My problem is when (in the above example), X is...

Answered my own question - have looked in Excel 07 and this "feature" still exists in that version (although on the bright side it's so much more difficult to find it lessens the chance of anyone using security in the first place - I mean come on, Review???). Got round it via OnKeys intercept...

Nothing more complex than the following - Public Sub PWOff() ActiveSheet.Unprotect Password:="xxxx" End Sub Public Sub PWOn() ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True, Password:="xxxx" End Sub TIA

Might be making this sound more complicated than it is - there's no single piece of code I'm looking at, it's the functionality of the Ctrl PgUp & Dn that's suddenly gone to pot on this file when the sheet is locked via protection (as in Tools/Protection/Lock Worksheet - locked cells...

Hoping someone can help me here as I'm a bit confused and I'm sure I'm missing something simple. Essentially, on a multi-tab file, my code protects and unprotects the sheet quite a lot but when it's protected, the Ctrl & PgUp or PgDown stop functioning correctly, as in doesn't move tabs but...

Hope someone can help, bit of a noob question. Have tried hunting it out but my search-fu is obviously weak! I've got an xla I've unzipped and gone through the code. I'm trying to find 3 functions but am unsure how to find the function with the user32.dll to see what it does. Can anyone...

Doh, ignore last email - all I needed to add in was .SearchSubFolders = True 'sets the search to go through subfolders as well My bad, should really have tested this before asking. Apologies

Very useful - thx. If I have want to cycle through a ragged heirarchy of subfolders, would this be an easy thing to add? Thanks in advance