View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Need help with formatting / saving before I email my worksheet

Hi ExcelUser

Start here

http://www.rondebruin.nl/mail/folder2/mail2.htm
Before the Save code you can add code to hide the rows and columns

If you need help with this post back with more information


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"ExcelUser" wrote in message ...
I have created an Excel document that I want my coworkers to use as a
template that they will need to fill in every week. I want to email this
document (Excel 2003) which only consists of one worksheet to my co-workers
but I would like for it to look clean and neat when they open it, without all
the extra rows and columns showing up on the screen. I only want the rows
and columns that are part of this document to show up when they open the
file. In other words, I want it to look neat and clean, just like it looks
when I see it in "print preview" mode.

I thought about saving / sending it as a pdf document but then they wouldn't
be able to use it as an Excel template for the project that we are working
on. (They don't have pdf to Excel converters.) They will only be able to
use Excel 2003 to open the document.

How do format it before I send it and/or what do I "save as" before I send
it so that it looks neat and clean as I've described above?