Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

ResolvedVersion 2007

Wed 13 Mar 2013, 14:56 Delegate Terry said...

Terry has attended:
Excel VBA Intro Intermediate course

VBA

How do you turn off the password as part of what you want the macro to do eg not just turn it off and turn it back on.

Wed 13 Mar 2013, 20:06 Trainer Gary said...

RE: VBA

Hi Terry

Thanks for getting in touch.

Which password are you referring to?

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Wed 20 Mar 2013: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips

VBA

VBA

RE: VBA

Excel articles

Excel tip:

Ctrl+d's double life