Enabling macros while the sheet being protected !

You can still run macros even if the sheet is being protected. By the way, how are you currently running them. As for you other posts, are you running the web query though a macro, or have you set it up.

Mangesh

Dinesh,

Try the following to unprotect the activesheet:-

..unprotect password:="yourpasswordhere"

To protect the sheet try:-

..protect password:="yourpasswordhere"

HTH

Pank


"mangesh_yadav" wrote:

>
> You can still run macros even if the sheet is being protected. By the
> way, how are you currently running them. As for you other posts, are
> you running the web query though a macro, or have you set it up.
>
> Mangesh
>
>
> --
> mangesh_yadav
> ------------------------------------------------------------------------
> mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
> View this thread: http://www.excelforum.com/showthread...hreadid=377989
>
>

How about just unprotecting the worksheet, run your code and reprotect the
worksheet?

dinesh wrote:
>
> HI,
>
> I AM GETTING THE FOLLOWING ERROR WHEN I RUN THE MACROS WHILE THE
> SHEET BEING PROTECTED.
> ::-
> \\" RUN TIME ERROR '1004' SORT METHOD OF RANGE CLASS FAILED\\"
> -
>
> Actually I am refreshing a web query through macro.
>
> & dear pank... I don't know where to put the code.. Please tell
> me in detail.
> *
> Have a Nice Day !
> Dinesh Vijaywargiay
> *::
>
> --
> dinesh
>
> ------------------------------------------------------------------------
> dinesh's Profile: http://www.excelforum.com/member.php...o&userid=24177
> View this thread: http://www.excelforum.com/showthread...hreadid=377989

--

Dave Peterson

modify the code to unprotect the sheet as the first line of the macro and protect as the last line. a previous post states that code.

hit alt+f11 to open the vba window and add the code to the correct macro

sub name()

..unprotect password:="yourpasswordhere"

...the code that is currently there....

..protect password:="yourpasswordhere"

end sub

make sure you change "yourpasswordhere" to what your password is.

copy and past the following code as is to replace what you currently have: just change the password field:
sub name()

..unprotect password:="yourpasswordhere"

Range("A3:az28").Sort Key1:=Range("A4"), Order1:=xlAscending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

..protect password:="yourpasswordhere"

end sub

when it hightlights sub name(), where does it put the mouse curser or select the text in blue?

Good evening Dinesh

Why not use this line of code at the start of your module:

ActiveSheet.Protect UserInterfaceOnly:=True

This will allow your macro to make changes to your sheet with the protection still in place. This will not automatically take effect every time the workbook is opened, so you would have to tie it to an event procedure to run it every time the file is used.

HTH

DominicB