Printing formatted comments

[RareBug]

Hi,
In Excel 2003, it is possible to format comments with the formatting toolbar or by selecting text in the comment, right-clicking and choosing "Format Comment". However, these formats do not appear under File -> Print Preview, nor when the file is printed. Is there a way to print them, Any suggestions.
Thanks!

[AlpineMan]

Hi,
How would I write VBA code to select a range of cells say..A1 to A15 (I can do that part) and then number the cells in sequential order i.e.-1,2,3,..etc.
Thanks in advance.

[BurgoEng]

Hi RareBug,
If you print comments after the worksheet, they will be unformatted. To print comments as displayed on screen:
- Use the reviewing toolbar to display the comments you want to print.
- Select File | Page Setup...
- Activate the Sheet tab,
- Select 'As displayed on sheet' in the Comments dropdown.
- Click Print... or Print Preview.
Cheers!

[BurgoEng]

Hi,
Try this out:
Sub NumberCells()
Dim i As Long
For i = 1 To Selection.Rows.Count
Selection.Cells(i, 1) = i
Next i
End Sub

Select the cells first, then run the macro. I assume that you wanted to number only cells in the first column of the selection.

In addition the above code, and depending on exactly what you are trying to do:

Range("A1").Value = 1
Range("A1").AutoFill Range("A1:A15"), xlFillSeries

Cheers!

[RareBug]

Great, I will try it immediately/

[AlpineMan]

Thank you Burgo, I will try it out.

[AdamU]

There are 2 types of users, that use the same excel file stored on our server. They periodically both will be able to access the same file, neither being advised that the other is already accessing said file, and not giving the read only/notify message. It is some what weird behavior, has anyone else experience the same. I have tried to find in the help file but could not find and solution. Any suggestions would be really greatfull.
Thanks in advance.

[BurgoEng]

Hi,
With the file open, go to Tools > Share workbook > and make sure the "Allow changes by more then one user at the same time" box is unchecked (on the Editing tab.)
Cheers!

[DaveAtkinson]

I need to secure a column of sensitive data in an excel spreadsheet where the only persons with the proper password or access level should be able to view the column. I've looked at protecting the sheet, workbook, format-security and haven't found the right combination. Any suggestions?

[BurgoEng]

One way to HIDE data in Rows/Columns is to HIDE the Rows/Columns. When the person with the proper stuff gives the proper password, you UNPROTECT the sheet and UNHIDE the Rows/Columns and then REHIDE the Rows/Columns & REPROTECT the sheet when they are done.

And if you want to protect the data from being read then try this out:

You need to enter a few parameters and then read a few output cells you would set up an input and output sheet and then have all parameters and calculations on a different sheet. If the results cells (on the calc sheet) are then named, and the output on the input/output sheet only refers to them by name the users will be none the wiser about the inputs.

If you take this approach, name the calc sheet something obscure/alphanumeric and then write a quick macro:

Sheets("obscure_name_here").visible = xlveryhidden

Then protect the VBA Project (rightclick and complete the protection tab), then you can protect worksheets/workbook as you see fit and, unless the other users guess the name of worksheet or the VBA Project password it should be reasonably safe. There are still ways round it though if the other users are a bit good.