Hi everyone. How can I find out the password of a protected sheet?
I can't actually break it, but I just need to unlock it to fix something and
then re-protect it.
Any ideas?
--~--~-~--~~~---~--~~
--
quot; & I).EntireRow.Hidden = True
> End If
> Next I
> End If
> End Sub
> '==
>
>
> --
> *From:* Joe Wilson
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, April 29, 2009 1:57:04 PM
> *Subject:* $$Excel-Macros$$ Re:
ntireRow.Hidden = False
> For I = 3 To 1000
> If (Cells(I, 1) >= 3) Then
> Rows(I & ":" & I).EntireRow.Hidden = True
> cnt = cnt + 1
> If cnt >= LastRow Then Exit For
> End If
> Next I
> ElseIf (LastRow =
Hi group. Could someone help me with shortening the below Macro. Basically
I want to hide rows that start with the number 3 and goes to 18 or higher,
and you can see below how I did it the long way.
Is there a way I could have an input box popup that would ask me the # of
rows that I want hidden
.Path) = "xls") Then
> If File.datelastmodified > LastFileDate Then
> LastFileDate = File.datelastmodified
> LastFileName = File.Name
> End If
> End If
> Next File
> MsgBox "Last file: " &a
Hello group.
Does anyone know of a way using VBA code that would allow me to open a file
based on the file being the last saved file in a folder? IT saves a file
for me but adds a time stamp to the file name, which will not allow me to
open the file based on the file name.
Any help would be appr
