Attach a sample workbook
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need....
try:
Public Sub sing_off_formatting() 'Creates tabs for sing off analysis macroeach of the desired reports Set PS = Sheets.Add(After:=Sheets(Sheets.Count))
On each of the sheets concerned, unlock all the cells on the sheet, then lock the cells in the columns containing the formulae you want to protect....
p45cal Yesterday, 11:53 PMThank you so much, that sound perfect if we can protect it. However does the query will still be able to refresh? That's what I did earlier were I tried...
mielkew Yesterday, 10:52 PM
how to add additional date and other column PIVOT table?
Hi all,
majid Today, 07:13 AMi need your help to understand this how the attached file add to extra column in a pivot table. i received from some one but don't know...