Disabling Page Setup?
Hi, I'm fairly new to Excel and was wondering how one might be able t
Disable the Page Setup menu in Excel? Any suggestions would b
appreciated. Thank you
Plazzma's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2523
View this thread: http://www.excelforum.com/showthread.php?threadid=38722
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=247, Recursive:=True).Enabled = False
You must also disable printpreview
See for more info
...copying page setups within a workbook
The first page in my workbook is formatted exactly the way
I want all pages in the workbook to look, INCLUDING the
page set-up i.e. header, footer, paper size, margins etc...
How do I copy these setting to subsequent pages within my
Select the page that has all the formatting.
Hold down <Ctrl> and select the other page tabs that you wish to have the
After you release <Ctrl>, make sure your *master* page tab is in bold.
Now go into page set-up and simply click <OK>.
=======================================================...Page setup #3
I am unable to 2 different page setups in Microsoft Publisher within the same
document. I want, for example, page 1 to be in Portrait layout, page 2 in
Landscape and page 3 in Portrait. But when I change one page to, for example,
Landscape layout, the rest of the pages also turn out in Landscape. How do I
change different pages in different layout?? P.S. I've tried creating a new
master page for the landscape page, but that didn't work either.
Carol <Carol@discussions.microsoft.com> was very recently heard to
> I am unable to 2 different page setups in Microsof...Page Setup Problem with Access 2003
I copied a database file from one PC to another and now have problems with
page setup for reports in the second PC. The page size has been changed in
the copied version from A4 to Letter and Page Setup will not let me change
that setting. (it will let me change from Landscape to Portrait but will not
allow the paper size to be changed). The printer default settings are all
OK and Page Setup for reports in other Access databases act normally.
What has gone wrong and how do I fix the problem?
...change page setup from printing 1 business card to 2 rows of 5
the program wont let me make this simple change. all i want to do is set up
the page so that it prints the card in two rows of 5 but there is no way to
Oh but there is, give this a try.
Here's I do it with Publisher 2000.
Business Card from the drop down menu
Assuming you are using standard business card stock of 2 wide and 5 high;
Page options button
Print multiple copies per sheet
Custom options button
Margins = .5"
Gap = 0"
Side Margins =...workbook page setup changing on different computers
This has happened to me a couple of times - when my workbook is opened on
another computer (primarily our print room co-ordinator who has to send the
document to print) the page breaks are not as I saved them. Am I doing
something wrong? Is there a logical explanation for this and how can I format
it so that it doesn't happen?
Any suggestions/tips appreciated.
You and the coordinator should use the same printer and same print driver versions.
Portland, Oregon USA
wrote in message news:90E18F1...How do I restore page setup/view to normal?
I don't know how it happened, but the way my doc is viewed on the screen is
all messed up. There is no margin on it (the blinking line for typing is at
the very top of the page) despite repeated clicking on "Normal Margin." When
I go to "Print Preview" everything looks ok, but the normal view is very off.
The proportions aren't right, but the point is, I don't know how to
restore/reset everything to normal. Please help! Thanks!
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fa...Why does the source on Page Setup keep changing from 'sheet' to '.
Have been trying to print a 4 page folded brochure on 11 x 17 paper. After
setting both the Page Setup and the Print Properties to the proper settings,
then attempt to print. Sometime during the loading to the printer the
settings are changed from 'sheet' to 'CD/DVD' in the Source on the Page setup
or the paper is changed to 8 1/2 x 11. Have checked with Epson and they have
clarified that it's not a printer problem. Any help would be greatly
Open the printer folder in the control panel, right-click your printer, click
printing preferences, be cert...Form Page Setup
I'm trying to configure my for to print on 1 standar 8.5 by 11 sheet of
paper, but it keeps printing the borders on several other sheets of paper.
I've tried going to page setup as well to make it print on one sheet with no
luck. Any help is greatly appreciated.
Your best bet is to create a report based off your form. You can then create
a command button on the form that prompts you to run the report. You can get
your report to prompt you for a parameter like recordID and allow you to
print the records as you chose.
> I'm trying to configure ...Why is the Print Titles option in Page Setup:Sheet greyed out?
I am trying to print the column labels on each of a 10 page list. When I go
to Page Setup, then the Sheet tab, the items under Print Titles are greyed
out. i.e. I can't enter a row for the "Rows to Repeat at Top" option.
Anyone know why? Can't find anything in the help file.
> I am trying to print the column labels on each of a 10 page list. When
> to Page Setup, then the Sheet tab, the items under Print Titles ar
> out. i.e. I can't enter a row for the "Rows to Repeat at Top" option.
> Anyone...paper size not listed in page setup
I'm using office 2003. When I go to page setup - Paper tab - In the paper
size box I cannot find the 11x17 option. I looked on other machines and it is
listed in theirs. Do I have to add it somehow?
Word displays only the page sizes that are defined by the currently selected
printer driver. If you happen to be pointing to a printer that can't handle
anything larger than Letter size, then you won't see 11x17" in the list. Make
sure you've selected the same printer as the other computers have.
Microsoft Word MVP FAQ: ht...Different Page Setups in the Same Document
I would like to make the mail merge side of my document be landscape but the
postcard (1x4) side to be portrait. I want both pages in the same document
so that I can duplex to my copier. Is this possible?
> I would like to make the mail merge side of my document be landscape but the
> postcard (1x4) side to be portrait. I want both pages in the same document
> so that I can duplex to my copier. Is this possible?
No, but you can group objects and rotate them in order to achieve the
same end result.
Ed Bennett - MVP Microsoft Publisher
...Excel XP: Page Setup Issue
How can I create different page setup options for each worksheet in a workbook? As I change the page setup within one worksheet it changes all of them. Is there a way to do this? Am I missing something obvious
Thanks in advance
"Joe Mathis" <firstname.lastname@example.org> wrote in message
> How can I create different page setup options for each worksheet in a
workbook? As I change the page setup within one worksheet it changes all of
them. Is there a way to do this? Am I missing something obvious?
>...excel page setup
I have a spreadsheet and I am using cells a:k50, but when
I go to see the end of my spreadsheet it tells me I have
used cells a:ak 295. I have 35 sheets like this and is is
making the file bigger than it has to be. I have tried
deleting, clear, page preview setup but nothing seems to
clear and make my page a1: k53. Any suggestions. Thank You
Select the row following the end of your data. Ctrl+Shift+Down Arrow to
select all rows beyond your data and Edit>Delete.
Select the column following the end of your data. Ctrl+Shift+Right Arrow
(US) to select all columns beyond your data...Publisher Should Allow Multiple Page Setups
I do an eight page newsletter in Publisher every month. One page always
contains a monthly calendar. In order to fir everything we need on the
calendar, it needs to be printed in landscape mode, but the other seven pages
are all in portrait mode.
It would be nice if Publisher would recognise that some pages could be in a
different format than others.
Why don't you create that page separately, rotate it and then paste it into
your newsletter? No, it's not a one-step deal but it works.
MVP Microsoft [Publisher]
"Westley Annis " <Westley A...Page setup for 8.5x11 calendar w/picture on tabloid paper?
How can I set up a calendar with 8.5x11 (landscape) pages with pictures for
each month to print on tabloid (11x17) paper so it can be saddle stiched? I
would like the picture on the top half and calendar on the bottom half. I
keep ending up with two of the same pictures on one page and two calendars
on the next page. Thanks, Bob
I assume you are taking this to a professional printer so why not just set
each page up as a landscape 8� x 11 and let your printer do the rest?
MVP Microsoft [Publisher]
"Bob at 4799" <Bob at email@example.com>...Inches not an option in page setup
I want to use inches not points to set margins, but that option is no longer
available. Don't know when or how it changed. But I'd like get back that
option. Can anyone help me change the page setup default to go back to
In all versions there is an Options setting to select units of measurements,
but the location depends on version. It's on the General tab of Tools |
Options in Word 2003 and earlier; in Word 2007 I think it's buried somewhere
in Office Button | Word Options | Advanced.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Ty...page setup landscape, but print footer in portrait mode
I have several pages that are being compiled. Most of them are printed in a
portrait mode, but several are in landscape. I would like to print page
numbers on all of them in the lower right hand corner. The landscaped pages
will be turned facing the right of course, so the page number needs to print
in the left hand margin turned 90 degrees.
not possible without VBA. You may record a macro while
- set the page layout for the first pages
- print these pages
- change the page layout (landscape)
- print these pages
> I...Page Setup is Slow
Can't honestly say whether this has always been the case or its just started
to happen, but configuring anything in the 'Page Setup' dialogue box is
incredibly slow at the moment. This is on a corporate network, from a
networked laptop to a networked printer. Printing is via IP, I am told, and
is working fine.
Anyone got any ideas please.
...Sort & Page Setup Question
Hopefully this is the correct forum for my question/problem. I am trying to
create a songbook that includes both an Artist Name (Column A) and Song Title
(Column B). What I would like to do is have the artist name column continue
on the same page in a third column (Column C) and the song title column
continue in a fourth column (Column D). So, as an example, Artist Names
beginning with "A" run down the first colum and continue alphabetically in
the third column and then start on the second page in the first column and so
on. The best way I can describe the format I want is...Page setup / page / size??????
When you are in design view and you click on 'Page setup / page / size' are
the options listed based on the printer you have installed or are they
options that Access knows? If I select any of the options listed will they
work on any printer?
They are printer-specific.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Phillip" <Phillip@discussions.microsoft.com> wrote in message
news:92C07A38-11FE-4620-97C...Page Setup #3
After selecting Landscape orientation in Page Setup, print preview continues
to display the document in Portrait orientation. Never had this happen
before. Any input on why this is happening?
...Page Setup Dialogue Response Very Slow
Tried this a while ago but did not get a response.
the page setup dialogue box in MS Access is very slow to appear and respond.
Doesn't matter whether this is to the network printer or to the local
'Microsoft Office Document' printer. It hasn't always been like this but
don't what has caused the change.
Anyone got any suggestions please?
That's probably a Windows problem, but may very easily be caused by an
Anti-virus program, or by permissions.
Arvin Meyer, MCP, MVP
http://www.acce...page setup feature is not working
We have a user at our firm that has Excel 2002. When he goes into page
setup and changes the view to landscape, nothing within the document
actually changes. When you go to print preview, the document is still
in portrait. we have tried repairing the installation of office and
that didn't seem to work. We will try to remove it and then install it
again. I wanted to see if anyone has had this problem before. Thank
I often find that these types of issues are directly related to th
attached printer. Before uninstalling, try selecting a differen
printer (if possible) or verify t...Keep report page setup when converted to PDF
I'm using ReportToPDF to convert my reports to PDF files for emailing and I
was wondering if there's a way to preserve the local report page settings
when it's converted to a PDF. For example, most of my reports are formatted
for Legal paper with Landscape orientation. When I convert them to PDF, the
PDF file page setup is Letter/Portrait and so in order to fit all contents
on one page when printing, I have to manually set the page to
Legal/Landscape. Is there some way to preserve the Access report settings
in the converted PDF or am I S.O.L.? I'd appreciate any help...