Excel Tips - Worried about security? open Excel Safely

I've been trying to get our IT guy to answer this question for me but I wanted to see your opinion as well...

We run Excel 2000 on several systems in my department. Other systems in my department use Open Office. We have a few Excel files that we have password protected against modifying. However, when one of these files is opened using Open Office, the program doesn't require a password to modify and save changes. Then upon opening the file using Excel (after is has been opened using Open Office), it too no longer requires a password to make changes.

Any ideas????

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

Hey,

Has anybody noticed that all the help sections of the date/time help in excel tips is missing any information that's normally there?

just thought I would mention it.


oliver.

Good afternoon/morning/evening.

Many thanks to all of you who have requested and suggested tutorials to
be posted on my blog http://teachr.blogspot.com over the past couple of
days. I'm currently working on more new content for the blog and
really appreciate your input.

If you have any more ideas please please keep them coming, as I want as
many tutorials, tips and hints for excel as I can get to keep my blog
interesting an useful to those who visit.

Once again, if you have any requests, ideas or tutorials of your own
for the site, please email me at mattyboy150279@gmail.com and let me
know. Similary if you want an update on new tutorials posted please
send me a similar email with the heading SUBSCRIBE, and I will update
you whenever there is new content.

Thanks again, and keep 'em coming!

Kindest Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials

Good afternoon/morning/evening.

Many thanks to all of you who have requested and suggested tutorials to
be posted on my blog http://teachr.blogspot.com over the past couple of
days. I'm currently working on more new content for the blog and
really appreciate your input.

If you have any more ideas please please keep them coming, as I want as
many tutorials, tips and hints for excel as I can get to keep my blog
interesting an useful to those who visit.

Once again, if you have any requests, ideas or tutorials of your own
for the site, please email me at mattyboy150279@gmail.com and let me
know. Similary if you want an update on new tutorials posted please
send me a similar email with the heading SUBSCRIBE, and I will update
you whenever there is new content.

Thanks again, and keep 'em coming!

Kindest Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials

Good afternoon/morning/evening.

Many thanks to all of you who have requested and suggested tutorials to
be posted on my blog http://teachr.blogspot.com over the past couple of
days. I'm currently working on more new content for the blog and
really appreciate your input.

If you have any more ideas please please keep them coming, as I want as
many tutorials, tips and hints for excel as I can get to keep my blog
interesting an useful to those who visit.

Once again, if you have any requests, ideas or tutorials of your own
for the site, please email me at mattyboy150279@gmail.com and let me
know. Similary if you want an update on new tutorials posted please
send me a similar email with the heading SUBSCRIBE, and I will update
you whenever there is new content.

Thanks again, and keep 'em coming!

Kindest Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials

Good afternoon/morning/evening.

Many thanks to all of you who have requested and suggested tutorials to
be posted on my blog http://teachr.blogspot.com over the past couple of
days. I'm currently working on more new content for the blog and
really appreciate your input.

If you have any more ideas please please keep them coming, as I want as
many tutorials, tips and hints for excel as I can get to keep my blog
interesting an useful to those who visit.

Once again, if you have any requests, ideas or tutorials of your own
for the site, please email me at mattyboy150279@gmail.com and let me
know. Similary if you want an update on new tutorials posted please
send me a similar email with the heading SUBSCRIBE, and I will update
you whenever there is new content.

Thanks again, and keep 'em coming!

Kindest Regards,
Matt
http://teachr.blogspot.com - For Excel Tips and Tutorials