[AccessD] Excel formatting question

Jennifer Gross jengross at gte.net
Tue Oct 2 11:03:46 CDT 2007


Hi Arthur,

The sheet that you want to turn Gridlines on for needs to be the active
sheet.  Page Setup only effects the current active worksheet.

Jennifer

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of McGillivray,
Don [IT]
Sent: Tuesday, October 02, 2007 8:55 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel formatting question


Arthur,

This ought to do it . . .

File|Page Setup
Sheet tab
Gridlines checkbox

You can also get there from the print preview screen.  Click the Setup
button, etc . . . 

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Tuesday, October 02, 2007 8:38 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Excel formatting question

Given how knee-deep I am lately into Excel programming, this will
doubtless seem a stupid question, or evidence of a stupid inquirer, but
anyway... I have a workbook which contains two sheets. One prints with a
grid (boxes around each cell) and another prints with just white space
and values. I want the second to print the grid, same as the first. What
do I adjust to make this occur?

TIA,
Arthur
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com





More information about the AccessD mailing list