Napravio sam program za stampanje otpremnica i sve radi medjutim imam jedan problem. Imam jedan sheet gde se vrsi unos, znaci izabere se vise stavki iz padajucih lista i vrsi se unos pritiskom na jedan button koji startuje makro kojiu sustini izabrane podatke prebaci na sheet gde je otpremnica. E sad ovaj unos funkcionise kako treba ali kada sse heet u kome se vrsi unos zastiti sa tools->protect sheet onda on odradi unos i javi gresku visula basic 400. Sta ovo predstavlja i kako ovo resiti? pozdrav
protect sheet i vb greska 400
Zaključano
Zakačeno
Može li ti ovo pomoći ?
btw: uz to "možda" može biti problem kod zaštite ( možda u kodu da napraviš provo unlock a potom ponovno lock ) nadam se da si me shvatio a možda i nisam u pravu
pogledaj link How to run a VBA macro on a protected sheet
Citat:
Form already displayed; can't show modally (Error 400)
You can't use the Show method to display a visible form as modal. This error has the following cause and solution:
· You tried to use Show, with the style argument set to 1 – vbModal, on an already visible form.
Use either the Unload statement or the Hide method on the form before trying to show it as a modal form.
You can't use the Show method to display a visible form as modal. This error has the following cause and solution:
· You tried to use Show, with the style argument set to 1 – vbModal, on an already visible form.
Use either the Unload statement or the Hide method on the form before trying to show it as a modal form.
btw: uz to "možda" može biti problem kod zaštite ( možda u kodu da napraviš provo unlock a potom ponovno lock ) nadam se da si me shvatio a možda i nisam u pravu
pogledaj link How to run a VBA macro on a protected sheet
Hvala Ivane sta drugo da ti kazem :) Resilo je problem ovo sto si predlozio,unlock na pocetku makroa a lock na kraju, jos jednom hvala, pozdrav