1. R

    Read Only

    Is there a way to make this save the copy as read only? path = "\\hinas1\MFG\LED\SSL Paperwork\U502\U502FogLBFirstArticle" nom = Left(ActiveWorkbook.Name, (InStrRev(ActiveWorkbook.Name, ".", -1, vbTextCompare) - 1)) & " " & Year(Date) & "-" & Format(Month(Date), "00") & "-" &...
  2. R

    VBA save as Path

    Is there a way to have the path = a cell in the workbook something like =range("setup-lamp types!I1") the above doesn't work, so is there another way? Sub Save1() Dim nom As String Dim path As String path = "\\hinas1\mfg\S8WData\Christine Myhaver" nom = ThisWorkbook.Name
  3. S

    any idea?

    hello all, how i can do it? <tbody> 1 same nom same nom 1° 2 same nom same nom 2° 3 same nom same nom 3° 4 same nom same nom 4° 5 same nom same nom 5° 6 same nom same nom 6° 7 other name other name 1° 8 other name other name 2° 9 other name other name 3° </tbody>
  4. R

    Save as Read Only

    Is there a way to add to the following code that when the copy is saved it saves as read only? Sub Button28_Click() Dim nom As String Dim path As String If Range("K45") <> 33 Then MsgBox ("Review Your Entries, Something Was Missed"), ActiveSheet.Protect, exitsub Else path =...
  5. R

    VBA Read only on a copy

    i have the following code that saves a copy of a file to a location. Is it possible to make it save the copy as a read only? Sub Button28_Click() ActiveSheet.Unprotect "987654" Dim nom As String Dim path As String If Range("K45") <> 34 Then MsgBox ("Review Your Entries, Something Was Missed")...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...