::Guys,


How to run the macros while the sheet is being protected.

Any ideos.

Please reply me at *::


--
dinesh


------------------------------------------------------------------------
dinesh's Profile: http://www.excelforum.com/member.php...o&userid=24177
View this thread: http://www.excelforum.com/showthread...hreadid=377989

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

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

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

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

UNPROTECTING THE SHEET, RUNNING CODE & AGAIN PROTECTING SHEET..

THAT'S NOT THE SOLUTION.

I REMEMBER THERE IS SOME METHOD OF MODIFYING THE VBA CODE... BY
ENTERING THE PASSWORD IN THE CODE... I AM NOT ABLE TO RECALL


--
dinesh


------------------------------------------------------------------------
dinesh's Profile: http://www.excelforum.com/member.php...o&userid=24177
View this thread: http://www.excelforum.com/showthread...hreadid=377989

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


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=377989

::Thanks kaplan.

Is that code correct? I am getting some error.

Can you please modify my code. My code is :

SUB NAME()
'
' NAME MACRO
' MACRO RECORDED 3/14/2005 BY DINESH
'
' KEYBOARD SHORTCUT: CTRL+Q
'
RANGE(\\"A3:AZ28\\").SORT KEY1:=RANGE(\\"A4\\"),
ORDER1:=XLASCENDING, HEADER:= _
XLGUESS, ORDERCUSTOM:=1, MATCHCASE:=FALSE,
ORIENTATION:=XLTOPTOBOTTOM, _
DATAOPTION1:=XLSORTNORMAL
END SUB

Regards,
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

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.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=377989

I AM NOT GETTING IT... DOES THOSE TWO DOTS NEED TO BE THERE...

CAN YOU PLEASE MODIFY MY CODE...

I AM GETTING ERRORS LIKE... 'CAN'T EXECUTE IN BREAKE MODE'
'IDENTIFIER OR BRACKETED EXPRESSION'

I WILL FILL THE PASSWORD FIELD...

REGARDS,
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