LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 30
Default lock shapes to grid by default

I've used Visio in the past and it is definitely powerful. But I can't
justify purchase in my new place of work so I guessed I'd use Excel.
I have a template with narrow columns to make a convenient grid, the
"SnapToGrid" macro run-on-opening that this thread was originally concerned
with, and a custom toolbar.
I like this setup because it's very convenient combining with Word - a
flowchart down the right and explanations down the left. A double-click
activates my flowchart and gives me my toolbar and I can still see the whole
Word doc. If I remember correctly, this is something Visio didn't do -
double-clicking a chart embedded in Word would open Visio fully and you work
on your chart seperately.

--
David M
WinXP - Office2003 (Italian)


"LAK" wrote:

Hi,

I am a novice in flowcharting.

1) Should I use Excel, or, Powerpoint, or other Microsoft Office program?
I appreciate your comments.

2) On locking shapes to grid, your instruction here still holds true?

Thanks,
--
"LAK" wrote


"ShaneDevenshire" wrote:

Hi,

First I would display the flowchart shapes toolbar. (Assuming you are using
Excel 2003 or earlier):
1. On the Standard toolbar click Drawing.
2. On the Drawing toolbar open AutoShapes, and open Flowchart, drag the
Flowchart submenu away from the AutoShapes menu by grabbing its title bar,
the gray dotted line at the top of the pop out menu.
3. To get the shapes to lock the the grid on the Drawing toolbar choose
Draw, Snap to, Grid. This will make snap to grid the default.
On a case by case basis you can activate snap to grid by press the Alt key
as you drag a shape around. But once you have set the default to Snap to
Grid, then the Alt key will temporarily turn off snap to grid as you drag.



--
Cheers,
Shane Devenshire


"#DIV/0" wrote:

Good morning,
I do a lot of flowcharting and would love to find a way to get Excel to open
with shapes set to lock to the cell grid by default (excuse me if the terms
aren't always correct - I'm translating from the Italian version of
Excel2003).

--
David M
WinXP - Office2003 (Italian)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Naming Auto Shapes and Creating new Shapes AL2000 Excel Discussion (Misc queries) 3 September 10th 07 04:12 AM
How do I set caps lock as default? Mark Barnard Excel Worksheet Functions 1 April 15th 07 03:17 PM
When drawing shapes in excel the shapes keep disappearing Tape Excel Discussion (Misc queries) 1 October 6th 06 04:23 PM
How can i get more 3D shapes for Auto shapes in excel? Ajey Excel Discussion (Misc queries) 0 March 3rd 05 09:53 AM
Make default insert sheet to have grid lines Bruce Roberson New Users to Excel 4 January 20th 05 12:27 AM


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"